SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291868 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291868 [ RunTime:0.002840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517967,846937,751943,1025065,395141,490737,688615,227342,588099,792750,372085,420867,544293,676215,816667,953402,908093,561179,421661,604166,753369,296880,211449,108560,780028,119460,522561,217935,1028239,88859,700441,600725,721553,178254,852099,798990,682559,309556,182329,800084,127746,846216,1047593,390186,513861,786887,487120,71388,248677,871082,4895,538151,707861,941182,279167,130490,264357,168484,121905,448037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291868 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291868 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]