SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418005 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418005 [ RunTime:0.003082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647359,511806,131664,982213,147454,296789,281797,89450,788525,847568,1020231,813420,598442,633293,869811,1018332,171246,453327,436521,756404,632319,863785,454712,765348,285554,986616,355017,316333,777595,306276,485325,281184,573633,616495,479113,583315,1005825,534962,880069,618310,876554,936317,634070,1004971,63034,834940,166618,32997,871320,343827,670067,451685,246245,914649,1023262,81294,660390,165712,712553,446138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]