SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046212 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046212 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20145,98623,511980,70149,392864,41307,264006,226294,520503,566223,929908,303397,553447,454810,375696,824103,737716,130697,72183,978617,619571,548829,326498,417244,299139,11280,296145,525235,526999,218119,706300,284029,721661,856130,971614,580018,120153,747730,345027,261760,302185,266426,914123,411610,58961,511738,274810,784838,244151,315534,64251,322735,493658,400474,722405,715844,530647,913095,655236,795022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]