SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501462 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501462 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040843,519219,734616,866417,670887,437097,666244,103131,936795,1029235,735923,757216,562090,442537,191382,830771,912504,745291,665979,685303,964859,346190,1020405,738757,577977,674165,186013,403016,717494,130552,32621,473351,922932,94226,770502,289981,192613,551350,929119,1016400,847925,472236,310181,212052,408857,934316,854221,321594,463921,840312,596569,415238,206308,824054,441690,900736,56406,1009695,951953,583498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]