SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107091 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107091 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442062,568083,1037108,450883,27194,310034,138825,467853,509123,427754,224502,759514,968569,63064,254117,851250,130277,90549,155307,545,287126,329279,254113,516216,675276,80721,526736,55171,273323,355248,401606,1046229,329195,887868,499602,63826,212131,574911,916862,123943,402827,718914,126720,319612,979230,513008,712063,866866,81103,612937,969745,1001518,367658,266582,1021844,205689,545303,60517,685067,285178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]