SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515712 LIMIT 1 [ RunTime:0.000741s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515712 [ RunTime:0.003222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953250,50034,490708,435124,454270,593093,273950,373547,655349,277536,732548,775704,260614,747426,626408,717032,370582,1030992,299204,758248,827204,637795,349624,489558,600165,902933,45351,603730,375593,388161,847081,58215,706875,864615,236142,75004,893338,403261,443573,56643,657497,192187,201005,251076,45520,482709,244574,665242,864469,467093,928548,898391,72298,1015053,197872,729775,938570,378794,263292,466759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001708s ]