SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901531 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901531 [ RunTime:0.003671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827440,934722,801614,877641,688811,979782,387001,27660,92269,200500,412058,847505,742826,675257,486124,1014474,1014912,584661,800049,1010421,644268,750879,484218,350648,1013128,275099,280619,1023096,1016807,487245,852243,548195,105672,851365,242960,810280,945307,624351,239731,773857,36166,928354,121776,950319,353314,193400,282140,491643,627854,487007,270685,988403,632037,728901,699574,725592,911766,304099,1012134,411744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001324s ]