SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424309 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424309 [ RunTime:0.004140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816844,111047,439476,638360,410281,366725,571904,695329,482807,434329,836604,964227,1004973,713064,292261,338528,458524,801904,904626,271004,453277,473382,804153,813080,332663,308042,312262,725574,885437,876915,788311,200921,254911,632325,950691,679947,186378,923398,173866,208114,1936,527835,411313,650585,1000784,743107,555556,578019,48606,763409,540523,747206,214176,820190,64932,783800,924295,887169,308378,111954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]