SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022760 LIMIT 1 [ RunTime:0.000997s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022760 [ RunTime:0.004679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894987,957409,586558,426703,536667,1038171,750936,390748,176686,682920,988156,485845,714134,160541,912788,806514,184082,8494,1002638,529728,682198,205991,565355,1040341,204604,896602,936326,184090,520650,778932,192356,884570,343943,1003607,675136,631265,1040323,436840,792438,96737,327933,757567,173911,986460,526685,675433,504403,241655,205733,762180,794436,20794,332462,410306,550150,201016,943253,124602,20746,491883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002034s ]