SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806241 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806241 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766994,910531,786025,504364,361240,346509,524199,335007,1020660,515634,567128,902663,947523,213165,1024953,496085,352915,105887,276099,271633,247308,569154,194809,468029,939006,992369,145940,256432,799589,55987,582550,993255,906067,770112,877249,574724,265908,129039,816407,757552,371038,727311,912222,684361,624488,193188,451045,225531,773893,299712,100239,183033,871857,261038,310643,506766,808055,829125,101060,1039642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]