SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804305 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804305 [ RunTime:0.002801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363594,854227,789370,996947,573363,954618,369085,195082,119549,359758,892122,12484,118066,191381,72329,341977,33447,405304,497354,830486,67956,193430,927930,347726,926181,440173,446487,435611,894906,608144,163644,806346,726502,812863,464661,259609,908991,882269,874846,541689,103399,462367,218384,134163,663683,909727,777823,1007859,234213,1017311,725033,117465,770238,869836,96022,140924,904461,489410,827639,167868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002010s ]