SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520010 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520010 [ RunTime:0.003254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528448,760674,869373,998235,31170,579307,210549,357754,156354,577669,103613,653485,742066,389362,284840,158690,933985,360309,300782,910056,747542,777664,391839,234086,145394,1043607,374110,455144,640820,599144,344284,449165,145345,629826,912010,44265,869735,287264,109138,678435,45047,990920,257029,961349,215926,638440,725116,136223,936849,431540,13771,628249,1043768,554293,562786,411923,183488,855480,778051,427458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]