SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409244 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409244 [ RunTime:0.002463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231805,738607,185822,200537,778399,316860,905839,608088,500920,700056,514801,916564,107213,861482,701722,136963,907414,930517,791419,1023844,225548,270595,953971,60095,207133,682350,242243,1022514,182474,478694,100594,762666,479474,732058,602624,614609,512869,898634,688056,52091,451002,863083,496072,367101,423381,302202,31878,553965,340697,828452,203772,223709,471771,749747,884556,420456,186570,270291,445206,551256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]