SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001903s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403931 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403931 [ RunTime:0.002849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548209,691083,494357,1019130,383930,399223,219374,711811,124158,150892,1000189,588693,438276,398199,312949,100128,451104,977931,589905,812922,454302,189659,492531,694809,886546,1023951,675637,106803,714014,685250,24023,508658,333634,80544,529628,484650,311128,869824,662338,342261,1012366,668374,139293,205025,780804,988938,44382,162856,527710,274411,26666,242922,346104,234477,750891,340269,444346,798920,568670,242571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]