SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026285 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026285 [ RunTime:0.002787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97754,279832,107652,591571,297939,876328,268605,211311,519007,226256,527904,636795,123760,285827,425582,336504,536199,963512,716842,385838,337224,594677,67875,373515,20626,44549,408134,587005,566989,153212,1032558,42051,305589,511362,209935,898239,681067,780934,1009770,983475,284036,155036,541486,478616,843974,749579,186229,534744,36841,988953,276714,960070,408366,135881,767377,30678,503771,747923,809080,659677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026285 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026285 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]