SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015217 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015217 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231792,459641,1865,370227,711484,281406,928574,195570,381102,48505,122929,443216,497343,1005694,904127,314486,287988,912886,494941,57620,118708,471622,623098,253160,449868,915653,575509,31624,1030791,533435,475864,634546,836127,569183,328413,526930,480593,552400,31481,125096,1028082,11218,522524,581498,641483,273903,384628,725325,855304,97904,322492,560098,683085,280672,101922,905712,857570,524699,447904,889700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]