SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348018 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348018 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256886,193577,636000,847671,477602,1047684,818822,432698,69930,57654,1001519,473113,717646,7858,1040166,104333,1013896,438414,346885,820404,638745,197452,445018,714965,519377,797419,760982,896951,249456,940513,715244,1042807,733748,21508,257427,133848,337635,758022,1018870,594419,925941,301816,612175,271592,557064,885006,176665,924846,848368,970436,530326,518080,609849,1013633,607210,35258,587436,213455,348654,908967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]