SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505193 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505193 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227533,835400,966600,880726,867657,732333,217279,155081,230911,314328,418328,230488,360242,827208,511085,132285,72,561359,350460,504073,843830,381447,1023926,815942,451246,481031,800480,618159,150397,1042267,653708,435367,787220,896671,740997,968723,169937,578765,555479,701769,975172,840738,102221,853696,872066,255333,347839,4781,129096,81914,479551,1036737,128303,264566,342750,288910,657483,5331,607245,888414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]