SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392506 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392506 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457110,945451,737422,651310,996687,703404,1041850,196183,149762,538427,859135,819533,787479,80316,814119,718683,571472,236936,151495,83344,407885,718809,167479,1037384,727274,704672,317202,251110,603635,434497,762094,775206,37088,26697,458761,657989,166804,466201,1048464,380067,1030397,208174,880876,834132,896375,961802,987872,57442,824660,990843,367870,660838,134862,1022053,671163,427135,934845,584190,127120,308741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]