SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200580 LIMIT 1 [ RunTime:0.000550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200580 [ RunTime:0.005209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286541,549027,627769,999263,1037690,65731,427473,178965,309149,961706,185362,413429,346789,556899,407549,144683,827520,484095,438003,300213,1034422,720852,473343,433080,88375,1003547,8963,257283,669870,458660,730584,4860,95838,305684,323137,983034,675057,973738,933695,373782,678174,440869,579355,637896,87133,938941,289522,460384,337711,1023279,773436,4434,1039415,683561,743282,73646,852877,513218,929399,449937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]