SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003835s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 161894 LIMIT 1 [ RunTime:0.002370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 161894 [ RunTime:0.004328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153278,698487,272754,626666,1034214,504676,610629,201201,147073,415528,945062,782516,714522,1041328,566878,396055,595928,561790,515609,978578,706210,867939,771527,540128,754460,998441,959652,153391,292928,823103,522955,390632,74683,735844,261991,493453,703512,624041,654190,135170,900429,657701,962583,45177,907256,867796,207497,629759,906532,200629,481648,194777,970601,186777,497673,93166,143588,880338,608870,77818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 161894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 161894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001184s ]