SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505354 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505354 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773058,821712,685030,521370,27120,215629,732735,447522,321626,236668,377528,914749,189022,224174,522347,467835,262548,308308,223068,224039,752889,9384,469122,832705,651893,554424,475203,265201,265807,58903,929489,890360,92821,688620,769669,441772,576505,475674,599148,608078,105877,130496,760896,814563,1005735,62592,1045594,588292,325587,752349,465953,358082,388959,85076,293337,890638,56783,1035099,974410,970727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]