SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535710 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535710 [ RunTime:0.003862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434309,373557,445148,253769,302860,553626,18304,520574,819700,637767,671284,424789,707536,759063,229069,480540,80542,589478,842486,714969,808274,272741,887805,486964,267319,376121,343382,497332,972570,796503,797816,335049,476382,711619,157753,1008015,379617,913181,806418,492841,851297,580954,939296,411151,975893,129069,599737,525431,220597,675212,216466,445031,497596,550793,980600,1037320,710030,836602,422746,543778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]