SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 744250 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 744250 [ RunTime:0.003282s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002148,446197,178787,741220,600569,188914,998729,1002094,454299,253314,800384,1047577,709782,220947,935169,971020,563020,884179,663249,1043782,287303,353431,437324,1038160,268119,422821,89255,320604,630592,481610,482234,168559,612640,625602,959176,468235,958996,1008495,488561,760068,961382,987969,269093,177884,64275,305085,235991,926236,768898,321753,329925,567880,890173,684643,327008,255694,1013378,494354,12682,428036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 744250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 744250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]