SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294686 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294686 [ RunTime:0.002268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11021,23654,50706,821439,748637,150718,918991,1000595,892393,288435,203866,430529,608579,517937,2906,569508,44079,140062,874805,799756,1006749,965759,414210,1016574,683770,559518,281097,421007,250442,468537,700574,816881,1029306,1001914,725307,45367,621548,23754,311767,215344,828502,817373,130902,457232,114696,398994,450673,384187,295883,120735,637792,342866,11999,255073,974734,304053,758214,775447,1028287,560969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]