SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400212 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400212 [ RunTime:0.002500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695151,298124,156411,481478,868460,714790,835736,587795,229262,607627,72504,1046781,126122,671693,272691,881450,461477,727860,803333,825127,238633,404023,453758,239904,340291,1014399,562979,163430,972846,117115,495755,778080,875783,1046919,60796,18693,888094,666465,336603,398153,839248,173928,401977,690789,274409,400860,488457,850337,708095,260320,926886,95215,912256,62228,707209,1019389,761878,111455,489276,626341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]