SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009106 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009106 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907089,57437,246265,954014,861399,694028,142934,568757,172360,906231,54697,345010,35368,436697,545479,1001730,161899,993814,445401,627309,599644,666914,110337,730529,275019,216712,832684,100480,760396,675646,677766,785544,989013,216139,72034,838559,975058,141159,128829,139990,166945,495524,5899,622110,256478,444725,343486,949176,748274,680835,46376,968261,385563,348537,251695,101511,60147,10461,535196,310403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]