SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809408 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809408 [ RunTime:0.002092s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697536,373428,1046444,47937,719242,704874,26165,1037569,981325,367337,248336,15036,747592,450862,783184,825903,277152,501949,608932,562281,563938,927946,214778,820015,341456,944175,55213,317091,140255,464218,822900,705557,396700,379445,830591,791991,125264,724637,903193,437282,1045410,708769,902504,1021529,42571,874638,932852,1017959,1034000,702716,978191,282468,789161,453341,19059,17506,143095,588305,592851,14171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]