SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501227 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501227 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885234,728980,189923,946989,25425,761974,700095,9832,523144,298139,892288,126590,543382,949584,387383,904883,439446,433115,52584,209420,901823,621294,391951,141226,1003731,1007962,279614,418204,804064,146584,875060,982026,354759,126281,691855,350079,382626,693811,148049,209239,1037519,748517,231833,389829,487477,177460,560587,14693,54559,982882,717223,989091,284647,208549,1045110,810319,893813,727989,80806,267277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]