SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416828 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416828 [ RunTime:0.001467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60322,1013293,474474,816966,343198,1014105,570589,915824,1012799,730620,586081,309804,826839,670649,803323,629239,12739,953574,670469,794182,91120,247479,432458,667729,413858,127565,475144,115671,75213,179294,997860,712399,110257,633112,178584,19109,678505,969317,782285,202865,256224,414532,773895,155736,897806,713317,678144,350323,618799,288446,930063,145273,976719,232078,115040,283580,347453,500527,24272,966513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]