SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543190 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543190 [ RunTime:0.001401s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317685,994043,376826,206438,981216,651061,1019112,1046168,376844,382922,484319,786366,396981,769855,115351,143865,815342,316932,950938,835093,747867,602636,723801,805477,1041496,8235,997688,430125,144408,552477,335549,1013387,1027621,903887,270850,681761,42969,132413,659048,683856,900095,71175,292750,295530,582267,142816,855053,704122,202856,743478,27365,656119,486229,870491,583040,496783,968300,716732,93541,71921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]