SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410760 LIMIT 1 [ RunTime:0.003871s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410760 [ RunTime:0.001370s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635496,75698,801493,498306,516911,667195,278980,955718,45532,15572,217363,698210,465152,656202,609406,657152,99247,757416,213918,109466,388798,372666,499665,242963,352468,1024726,733171,311066,447174,711502,590593,490226,649717,808512,420150,787947,95296,1025281,891543,969889,612893,933792,461783,714031,648098,324289,790317,471970,959392,180297,1028315,863936,525944,238784,997503,794252,242094,321111,655863,101997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]