SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453653 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453653 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475791,817600,1020728,934546,274290,201042,516677,625124,272155,756902,588647,860919,804006,342897,269559,793539,200020,627080,612030,557577,35405,986918,763833,1023553,644890,940155,779235,508341,550196,829414,1000110,314012,341948,13129,157092,890549,191857,968060,718273,866246,127281,644283,169721,637678,581120,319138,204733,685143,945723,214171,516597,149095,230340,819719,234128,625397,358607,788608,653035,156876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]