SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583631 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583631 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395071,440657,621149,236601,509164,122922,1000547,17990,899714,794023,269133,1041000,1886,924797,212900,112564,392546,101467,1003505,460188,544346,1019218,417359,948656,311119,964459,678117,17396,912582,467668,495785,620223,224989,676333,489156,243455,281955,150580,410259,363335,964965,954382,302399,233423,133464,234106,292430,330552,194270,132703,793612,103345,1399,866643,873928,818766,584342,300542,132705,266983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]