SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392976 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392976 [ RunTime:0.002331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72298,259282,580615,826151,801861,1002573,743645,992453,776292,138484,517124,265567,880436,527250,151491,185465,470610,562345,548148,896574,96911,288419,776531,550939,339932,201495,386797,434720,794623,168189,1038649,848625,205415,801259,367063,170634,1036362,629504,106272,453506,335179,54618,207166,951687,282680,531481,787539,783520,1046308,873780,80178,280658,965212,515431,991634,1029957,872900,419962,110502,722434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]