SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348621 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348621 [ RunTime:0.004355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538612,174324,145110,448060,345466,927889,1032037,439303,384860,467412,51965,825131,916363,175807,203493,909236,144714,189882,573374,220968,698283,91224,3343,508960,136964,22406,561856,442873,915610,574118,712253,405718,152912,552647,629209,227043,962431,199820,207550,1009570,825727,1027991,1000771,1001619,617604,43722,592671,695037,89848,287341,926413,365163,834988,386574,856183,699022,970984,246176,157970,291010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]