SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981827 LIMIT 1 [ RunTime:0.001148s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981827 [ RunTime:0.004434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22910,648727,326492,667996,914080,413345,529026,859168,757542,807127,296618,711530,320010,904991,425320,973882,730806,791860,356806,16464,719679,462441,627675,359277,310654,1026198,782895,495146,239589,29709,722284,535828,649760,404752,925643,907518,1002663,671387,149071,144814,373262,278147,316980,151854,383054,854265,977807,269885,983523,516899,968689,689377,788908,628367,451317,421052,296019,697890,737826,965078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002557s ]