SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020169 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020169 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788508,621112,840803,12777,363982,249326,319529,97093,849861,367124,140955,844733,634698,227677,618983,15514,136640,593102,525022,605045,131562,835173,317155,482760,696392,726145,982810,315507,431811,659877,50497,1041102,795262,457161,76418,638445,812302,711283,688433,204017,735156,838800,819043,668608,613979,298641,389277,368000,188655,46267,274140,737656,838351,331638,648518,11969,253740,923906,350256,718463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]