SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530311 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530311 [ RunTime:0.003133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642312,206578,5518,296661,331873,85596,998865,24173,212439,654977,459534,86852,810783,654170,837487,270819,940861,721448,978076,812244,264490,623881,207526,28099,117434,327702,148921,227217,586666,497519,330365,862206,910648,942334,93612,658465,1043328,993783,413597,492533,429695,19508,247316,843060,75267,950543,624425,931850,559053,309743,1005971,561818,565035,424817,406759,530185,585267,136975,208837,254188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001724s ]