SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475252 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475252 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702224,851985,828615,129359,568987,146902,888423,381019,113884,192743,1003132,930383,309733,372455,566913,859133,699277,725263,188442,341267,1029235,671997,678321,270718,998515,120408,374147,559739,242808,129679,442252,1044245,992724,570182,462905,858901,879223,835308,560361,368191,820715,1008415,90596,393816,510481,349159,340034,330573,449798,78975,474210,901199,267830,422622,684640,1034108,297022,736422,907838,313624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]