SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040750 LIMIT 1 [ RunTime:0.002664s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040750 [ RunTime:0.004073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332367,1029245,391021,243246,165165,198193,1044630,266416,88937,658679,682495,714070,517048,580535,475631,642695,586171,709577,240431,370480,969192,274826,889559,579577,386877,333701,437668,647991,697441,893679,404526,81792,897238,954502,269361,609076,940346,947117,206547,1008544,557724,249908,487845,146765,226317,208567,579411,170442,783133,33832,543532,135402,231013,139297,235307,255205,631858,495223,957686,850261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]