SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101118 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101118 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284425,1048696,833082,557603,878862,482438,417518,199853,839351,807250,11286,899524,4759,553120,328474,592337,391712,110240,72931,245014,840081,70336,142116,956940,289161,496680,186730,514000,364863,908116,676307,26934,682085,425812,168161,685741,367110,218735,85859,116892,448796,757064,299592,802805,887747,696306,914882,329970,748790,466740,363069,919770,202692,542798,589543,394602,553004,41783,673170,319706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]