SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 860380 LIMIT 1 [ RunTime:0.000622s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 860380 [ RunTime:0.002089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287142,136081,164607,79139,901124,41816,735924,931107,496473,331725,506694,839713,152912,640953,796439,250008,430554,242157,918599,516707,1013777,924812,129890,485982,109877,550199,563981,259704,255302,1048487,129999,260585,863752,622512,479040,480173,545122,270837,917123,40388,367773,357333,395781,609753,996416,738919,850472,146386,599572,445206,270580,715434,406697,772708,133908,491225,405686,889197,541899,161329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 860380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 860380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]