SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108075 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108075 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048102,807224,212965,926512,642043,230834,94021,76466,756062,335802,661221,226122,83977,837583,763301,1010394,879918,286418,721135,898997,163725,983981,37623,204433,199712,902223,6241,758759,953721,555845,14852,475933,394004,300349,991024,94698,527379,57235,641602,904200,380523,713388,781764,303526,63430,259376,397205,74354,793150,814393,153842,397645,755453,266065,968635,513809,731002,687339,17895,905511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]