SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026378 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026378 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536725,327323,705184,987852,891226,2832,1032363,278370,232269,449693,437066,56739,1038963,348878,860964,344539,364675,819581,458433,133003,911023,705414,517781,691761,166523,29026,337483,674406,191014,649692,806895,790939,903002,892308,530985,1000783,860218,860544,550061,6322,28425,611896,584268,192042,924778,459776,916503,36246,312977,416644,394677,292396,459851,742723,655037,883513,484566,240284,241074,913022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]