SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482586 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482586 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79153,38316,806070,126012,1004608,785443,647852,971498,312,431967,659076,9920,854928,988,26490,353174,455938,131027,478786,507464,878110,571656,197632,60763,808979,490023,1013899,104436,823620,525630,523372,722895,711763,338565,856561,71940,294398,470618,889672,238271,960872,1016820,717876,287445,670217,443450,908956,667294,144269,106589,151769,264565,48402,529381,247221,916263,280714,716546,2712,421543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482586 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482586 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]