SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001836s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269480 LIMIT 1 [ RunTime:0.004157s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269480 [ RunTime:0.006463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869581,562051,748320,116499,359390,367700,607360,51273,601692,332020,841072,679862,238148,91950,1037270,985114,601735,41894,31471,470840,78131,769843,1038582,207042,428027,477470,510089,864921,942520,302412,1022052,1004000,369673,566387,268625,228900,979156,30154,52440,147684,249261,208598,308102,15341,803701,187678,1043535,134117,288610,196160,916989,298775,489602,34071,727971,568359,378586,889449,505275,13081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002820s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.014185s ]