SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555856 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555856 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367323,158686,86079,632680,408465,60318,723615,1013498,777260,140377,718271,186802,818888,714621,384211,699054,396125,252998,762460,131136,831806,163971,315468,470632,987024,568433,64305,584909,364734,1020017,717510,690029,307595,1014232,773582,775842,530874,759542,803670,991581,429967,165314,997701,687420,157650,35237,401317,177922,599256,35267,449644,719393,57795,44947,621576,426225,747544,623771,904586,313614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001175s ]