SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545591 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545591 [ RunTime:0.003207s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150683,76666,48702,76414,249595,574339,850163,65267,676826,772803,443697,920613,921113,881053,385235,1043319,896252,29020,811436,31766,1004731,1005165,884914,239704,567308,135998,805343,414266,726692,693593,647981,160416,729497,613007,292600,741131,647604,99213,406903,932409,412392,552099,535913,455144,186000,175160,720420,64819,423409,1001352,418062,695668,461197,551519,259784,998379,737673,179248,447968,584904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]