SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 251618 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 251618 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732107,120539,432691,966756,632626,241774,877283,155659,905815,742490,42247,83896,119843,401749,468648,490010,143380,394043,124660,511015,635459,712968,524870,1001425,272527,83373,671420,707362,366554,389694,1026620,251567,698855,662557,968914,933248,838893,983814,621999,329711,925898,547199,295759,640552,347229,409690,712937,340250,331560,291752,273758,306118,868453,540157,920255,935273,649465,327826,188878,626171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 251618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 251618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002967s ]