SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38002 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38002 [ RunTime:0.002023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521911,363446,129619,599882,479502,305108,742664,421515,818334,771976,37158,375037,497894,563505,659493,48866,451673,1009045,22660,531988,944033,279629,128736,151531,279516,633290,883720,671536,238260,208484,720761,584099,63897,132750,398388,889629,53380,965597,285851,421319,138219,384294,77444,454225,352793,62217,440562,68253,346974,430541,120367,726776,264498,1002034,573304,293709,829671,509007,729430,95950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001501s ]