SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414295 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414295 [ RunTime:0.002048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839711,287040,697417,942307,990262,263367,991762,320386,781009,986164,985239,961683,78172,255096,711910,636103,877678,225799,386060,762437,621103,1038922,721159,680209,502063,311766,446941,4961,874422,739544,515794,653355,165854,639687,570367,677621,914206,108054,942910,250641,621168,283346,904136,139366,240291,1005425,390603,576479,958617,186819,1031007,44728,983,144461,828803,969011,595170,607129,729481,837194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414295 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414295 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]