SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584422 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584422 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773727,932634,41628,207637,405128,588551,1043501,201065,155388,290019,527475,1044373,932043,1039148,797394,544761,253234,941434,530559,200819,496077,879485,961076,132940,225293,121815,397446,465227,320490,846081,411233,138888,52353,7551,30034,600438,509559,678422,412371,40562,635190,899913,577862,510259,796670,823104,267002,953825,677737,329888,319790,653648,98092,400206,1012695,1004444,186576,828866,36328,298879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]