SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506740 LIMIT 1 [ RunTime:0.002072s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506740 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693664,778626,425325,1010349,134313,568324,303015,176711,549153,421409,548103,364073,181600,888750,1046010,582903,721584,726940,776790,989117,173185,322992,984464,245198,560828,850367,523713,406287,687779,1027976,65704,819189,872891,661462,95863,539082,803553,737044,734597,144872,938252,770293,870505,624744,835629,463945,178114,941999,1038012,947036,950277,987370,403372,324879,37859,74909,372935,256580,71455,717043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]