SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231510 LIMIT 1 [ RunTime:0.004244s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231510 [ RunTime:0.002063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428860,487581,327266,849646,423343,1047567,841707,85999,269097,599039,379762,152205,308292,195130,637087,146091,112489,972167,216951,707253,438003,249655,811078,1004085,97366,188246,12237,716356,154576,394162,541355,849790,604524,129617,443553,555427,488738,649140,157828,123070,8427,54277,942325,54776,967586,38540,54233,34002,255682,877466,330901,1024387,476840,684533,12590,1003537,1032214,484905,249701,534416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]