SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048171 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048171 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667725,218872,167298,696394,748806,427367,846586,838625,1013418,347589,245045,571963,546101,814167,1025971,289798,304750,601532,707590,300430,354547,221566,680549,923355,713604,427990,66546,735357,826006,173790,902315,788264,743350,240861,865108,63490,654585,193449,1001866,877400,82246,77396,492472,569943,678065,71419,808407,411507,29314,664313,119923,589071,921432,431989,39692,385775,778675,189380,1025358,728996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001893s ]