SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433040 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433040 [ RunTime:0.002118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182935,379250,447806,549516,368509,765956,104537,369798,605805,1010061,987609,426317,189555,965064,488820,148332,143436,962795,808997,366212,490023,544714,240696,651167,952317,583356,526826,121366,634650,1022767,36284,437646,714189,213031,927660,408482,71271,147498,64366,286895,367352,816473,820756,408029,994325,409706,277413,527805,534993,641281,1047140,722565,181289,989307,762877,861049,846132,504754,585681,1023967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]