SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524712 LIMIT 1 [ RunTime:0.000608s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524712 [ RunTime:0.004385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510477,907315,83022,1006945,515547,13231,13829,349062,893903,488443,37739,316034,2010,525073,880572,746762,654897,607494,394717,188942,77223,111728,776087,382027,36959,268429,438347,746132,1032859,357003,204011,306388,581917,906593,465712,230483,260175,426312,821240,900506,442902,341317,123285,603434,726387,578385,957397,984614,649731,526421,779647,565820,269928,352628,564138,771430,876231,105658,749092,162732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]