SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526064 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526064 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209573,87728,501794,360062,412290,338319,125009,496860,593815,614524,164683,797835,354531,382084,828406,105266,887550,882626,339205,698646,834935,361006,280469,941779,959373,324464,203007,761591,585928,248586,54052,614801,201160,303445,967125,806279,250903,269342,126983,454270,501097,176099,650509,426131,592018,840286,984868,708864,659442,361496,903406,288946,28172,1007721,540396,159560,637664,262400,410694,245985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001585s ]