SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840417 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840417 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624672,194168,644835,211882,731498,707485,186456,218267,264481,233254,1037497,1010983,186962,172557,111485,557558,540003,1043390,620214,867160,14626,241874,375226,727156,701239,1018756,1044701,766594,994104,1045290,619734,510219,12546,556192,727391,839596,63343,928405,333978,212826,437835,352394,606137,434304,987977,932294,332852,103540,504169,168642,98811,321848,379428,481360,1014336,110639,54207,248080,137940,78230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]