SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333902 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333902 [ RunTime:0.005640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699541,176488,483764,100701,71206,671834,49605,50792,610128,806974,127129,734770,990672,505259,14094,65830,740002,326080,408458,717388,124165,541241,379415,695954,252856,760205,26537,152292,325287,531965,732905,761912,212830,552911,588846,59699,473643,664748,933531,325871,463580,680563,391997,494820,270939,80564,551688,472334,292798,992335,855334,377993,825723,188079,712503,323977,69678,366510,311251,46252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]