SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302193 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302193 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246065,235499,354231,1011673,572361,776167,318511,435543,478092,890382,1033950,625756,322125,626867,725530,618405,509988,582719,309890,450334,1026953,725006,117380,561376,5690,161069,770343,822339,327748,325206,54663,326807,618959,206148,937836,845225,977337,413165,595988,333283,618910,293567,849284,123715,545635,159397,430219,542904,7269,54839,505834,674999,533269,473289,758810,632636,331670,1005448,535531,185030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]